Clustered Index Seek
Short Description
Seek within a Clustered Index and return specified rows
Detailed Description​
The Clustered Index Seek operator uses the seeking abilities of indexes to retrieve rows from a clustered index. The SEEK predicate positions the start of the retrieval, and an optional WHERE predicate allows rows to be filtered further. If the step is passed the ORDERED clause, the rows will be returned in index sorted order. If the ORDERED clause is missing, rows will be returned in the most efficient way which may not by in sorted order.
Additional Links​
- Microsoft Documentation - Showplan Logical and Physical Operators Reference
- Microsoft Documentation - Explain Plans
- Plansplaining - Hugo Kornelis' Blog series
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.